package com.watson.todolist.constants;

/**
 * This class contains database constant names.
 * 
 * @author Donnie Ward
 * 
 * @since 1.0
 */
public class DatabaseConstants {

	/**
	 * Database name
	 */
	public static final String DB_NAME = "watson_todo_list_db";
	/**
	 * Account table name
	 */
	public static final String USER_ACCOUNT_TABLE_NAME = "account_table";
	/**
	 * Table unique id
	 */
	public static final String ID = "_id";
	/**
	 * Table time stamp
	 */
	public static final String TIME_STAMP = "time_stamp";
	/**
	 * Account table user name column
	 */
	public static final String ACCOUNT_TABLE_USER_NAME = "user_name";
	/**
	 * Account table email address column
	 */
	public static final String ACCOUNT_TABLE_EMAIL_ADDRESS = "email_address";
	/**
	 * Account table password column
	 */
	public static final String ACCOUNT_TABLE_PASSWORD = "password";
	/**
	 * Change password request code
	 */
	public static final int CHANGE_PASSWORD_REQUEST = 0;
	/**
	 * Change email request code
	 */
	public static final int CHANGE_EMAIL_REQUEST = 1;
	/**
	 * TodoItem table name
	 */
	public static final String TODO_ITEM_TABLE_NAME = "todo_item_table";
	/**
	 * TodoItem user id
	 */
	public static final String TODO_ITEM_TABLE_USER_ID = "todo_item_user_id";
	/**
	 * TodoItem description
	 */
	public static final String TODO_ITEM_TABLE_DESCRIPTION = "todo_item_description";
	/**
	 * TodoItem location latitude
	 */
	public static final String TODO_ITEM_TABLE_LOCATION_LATITUDE = "todo_item_location_latitude";
	/**
	 * TodoItem location longitude
	 */
	public static final String TODO_ITEM_TABLE_LOCATION_LONGITUDE = "todo_item_location_longitude";
	/**
	 * TodoItem tag ids
	 */
	public static final String TODO_ITEM_TABLE_TAG_IDS = "todo_item_tag_ids";
	/**
	 * TodoItem category code
	 */
	public static final String TODO_ITEM_TABLE_CATEGORY_CODE = "todo_item_category_code";
	/**
	 * TodoItem item name
	 */
	public static final String TODO_ITEM_TABLE_TODO_ITEM_NAME = "todo_item_item_name";
	/**
	 * TodoItem todo time
	 */
	public static final String TODO_ITEM_TABLE_TODO_TIME = "todo_item_todo_time";
	/**
	 * TagItem table name
	 */
	public static final String TAG_ITEM_TABLE_NAME = "tag_item_table";
	/**
	 * TagItem user id
	 */
	public static final String TAG_ITEM_TABLE_USER_ID = "tag_item_user_id";
	/**
	 * TagItem tag name
	 */
	public static final String TAG_ITEM_TABLE_TAG_NAME = "tag_item_tag_name";
	/**
	 * TagItem alarm recurrence
	 */
	public static final String TODO_ITEM_TABLE_TODO_ALARM_RECURRENCE_TYPE = "alarm_recurrence_type";
	/**
	 * TagItem alarm reminder
	 */
	public static final String TODO_ITEM_TABLE_TODO_PRIOR_ALARM_REMINDER_TIME = "prior_alarm_reminder_time";
	/**
	 * TagItem tag completed
	 */
	public static final String TODO_ITEM_TABLE_TODO_COMPLETED = "todo_completed";

}
